New:

CREATE DATABASE highscores;
USE highscores;
CREATE TABLE pvphighscores (id SMALLINT 
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY, 
name VARCHAR( 30 ) CHARACTER SET latin1 
COLLATE latin1_swedish_ci NOT NULL, 
kills INT( 11 ) NOT NULL,
deaths INT( 11 ) NOT NULL,
rating INT( 11 ) NOT NULL,
honor INT( 11 ) NOT NULL);
CREATE TABLE mobhighscores (id SMALLINT 
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY, 
name VARCHAR( 30 ) CHARACTER SET latin1 
COLLATE latin1_swedish_ci NOT NULL, 
kills INT( 11 ) NOT NULL,
deaths INT( 11 ) NOT NULL);
CREATE TABLE minehighscores (id SMALLINT 
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY, 
name VARCHAR( 30 ) CHARACTER SET latin1 
COLLATE latin1_swedish_ci NOT NULL, 
coal INT( 11 ) NOT NULL DEFAULT 0,
iron INT( 11 ) NOT NULL DEFAULT 0,
redstone INT( 11 ) NOT NULL DEFAULT 0,
lapis INT( 11 ) NOT NULL DEFAULT 0,
gold INT( 11 ) NOT NULL DEFAULT 0,
obby INT( 11 ) NOT NULL DEFAULT 0,
diamond INT( 11 ) NOT NULL DEFAULT 0);
CREATE TABLE farmhighscores (id SMALLINT 
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY, 
name VARCHAR( 30 ) CHARACTER SET latin1 
COLLATE latin1_swedish_ci NOT NULL, 
wheat INT( 11 ) NOT NULL DEFAULT 0,
melon INT( 11 ) NOT NULL DEFAULT 0,
pumpkin INT( 11 ) NOT NULL DEFAULT 0,
pwheat INT( 11 ) NOT NULL DEFAULT 0,
pmelon INT( 11 ) NOT NULL DEFAULT 0,
ppumpkin INT( 11 ) NOT NULL DEFAULT 0);
CREATE TABLE blocks (location VARCHAR( 1000 ) CHARACTER SET latin1 
COLLATE latin1_swedish_ci NOT NULL);


Existing v0.5:

ALTER TABLE `pvphighscores` ADD `rating` INT( 11 ) NOT NULL ,
ADD `honor` INT( 11 ) NOT NULL 
